﻿CREATE TABLE [trUser].[tblContactTypes] (
    [IDContactType]  BIGINT        IDENTITY (1, 1) NOT NULL,
    [ContactType]    NVARCHAR (50) NOT NULL,
    [ContactURLRoot] NVARCHAR (50) NULL,
    [DateCreated]    DATETIME      CONSTRAINT [DF_tblContactTypes_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]    DATETIME      NULL,
    [DateInactive]   DATETIME      NULL,
    CONSTRAINT [PK_tblContactTypes] PRIMARY KEY CLUSTERED ([IDContactType] ASC)
);

